package com.example.dataservice.mapper;


import com.example.api.model.Product;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

public interface ProductMapper {

    /*利率平均值*/
    BigDecimal selectAvgRate();

    List<Product> queryByTypeLimit(@Param("pType") Integer pType, @Param("offset")Integer offset, @Param("rows") Integer rows);

    /**按产品类型统计数量**/
    Integer countNumByPType(@Param("pType") Integer pType);

    int deleteByPrimaryKey(Integer id);

    int insert(Product record);

    int insertSelective(Product record);

    Product selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Product record);

    int updateByPrimaryKey(Product record);
}